var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('test.db');

db.serialize(function() {

db.run("CREATE TABLE sensors(id_sensor INTEGER, org TEXT, func TEXT, type TEXT)");
db.run("CREATE TABLE data(id_sensor INTEGER, date DATETIME, data TEXT)");
db.run("CREATE TABLE andro_devices(id_gcm INTEGER)");

db.run("INSERT INTO sensors VALUES(1, 'a', 'b', 'c')");
db.run("INSERT INTO data VALUES(1, datetime('now'), '34')");

});


db.close();
